<%-- 
    Document   : forgot_storage
    Created on : Jun 19, 2012, 4:31:16 PM
    Author     : praneeth
--%>

<%@page import="java.sql.*"  %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>

    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>search_dealer_storage JSP Page</title>
    </head>
    <body>    <h3>your pwd is </h3>
         
             <% 
       try{     
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String a=request.getParameter("ha");      
      String b=request.getParameter("username");      
            System.out.println("area:"+a);
      String q1="select PASSWORD from ACCCREATION WHERE HINT_A='"+a+"' and USERID='"+b+"'";
            System.out.println(q1);
       
        Connection connection = DriverManager.getConnection("jdbc:odbc:egasdsn");
        Statement stmt =connection.createStatement();
        
        
       
        ResultSet rs =stmt.executeQuery(q1);
            if(rs.next()){
                String pwd=rs.getString(1);
                //String dname=rs.getString(2);
                //String area=rs.getString(3);







                
                                                                                                                         out.println(pwd);//+" Dname:"+dname+" Area:"+area);         
              //  String ha=rs.getString(4);
                  }
         //           
         
           //  {

         
         //}                  
            
               
        
        
        
        }catch(Exception e){
        }
       

    %></body>
</html>
